1. Baned on what join method(hash value) is generated . 
2. What is library cache 
3. Based on what method cost generated in explain? 
Its possible to create partition based list,range 
4.index prouning 
5.Ref cursor type. 
6.Hint append 
7. Hint Nocopy data 
8. query for departmentid without enployees. 
9. Query for employee who is getting more than their manager salary 
10. Collections types 
11. Is it Possible use Varchar2 in nested table 
12. What is Result cache 
13. Which method u will use to findout whether a data is available or not in nested table with records of 10000. 
14. Which location parse tree and explain plan will stored. 
15. Collection methods 
16. We are runing a program procedure inside dbms_profiler.if its successfully completed. U will get result in profiler table.Suppose it didnt complete where u will identify the line which is taking time or in which line it got struck. 
17. What is hard and soft parsing?